package com.jack.database_exp.mapper;
import com.jack.database_exp.bean.Buy;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Options;
import org.apache.ibatis.annotations.Select;
import java.util.List;

public interface BuyMapper {
    @Options(useGeneratedKeys = true,keyProperty = "BNo")
    @Insert("insert into buy (BTotal,BDate,PNo) values(#{BTotal},#{BDate},#{PNo})")
    public int insertBuy(Buy buy);
    @Select("select * from buy")
    public List<Buy> queryBuys();
}
